<?php
class Account_model extends MY_Model {
	
	public $table = 'ACCOUNTS';
	public $join = ' left join ACCOUNT_CATEGORIES on ACCOUNT_CATEGORIES.ID = ACCOUNTS.CATEGORY_ID
					 left join ACCOUNT_TYPES on ACCOUNT_TYPES.ID = ACCOUNTS.TYPE_ID
					 left join ACCOUNT_GROUPS on ACCOUNT_GROUPS.ID = ACCOUNTS.GROUP_ID
	';
	public $select = 'ACCOUNTS.*,ACCOUNT_CATEGORIES.NAME CATEGORY_NAME,ACCOUNT_TYPES.NAME TYPE_NAME,ACCOUNT_GROUPS.NAME GROUP_NAME';
	
    function __construct()
    {
        parent::__construct();
    }
	
}
?>